﻿CREATE TABLE [dbo].[AmixAmortizare] (
    [IDMijlocFix]       INT             NOT NULL,
    [Luna]              SMALLINT        NOT NULL,
    [An]                SMALLINT        NOT NULL,
    [ValoareInventar]   DECIMAL (18, 2) NOT NULL,
    [ValoareAmortizata] DECIMAL (18, 2) NOT NULL,
    [ValoareRamasa]     DECIMAL (18, 2) NOT NULL,
    [AmortizareAn]      DECIMAL (18, 2) NOT NULL,
    [AmortizareLuna]    DECIMAL (18, 2) NOT NULL,
    [DurataNormata]     SMALLINT        NOT NULL,
    [LuniAmortizate]    SMALLINT        NOT NULL,
    [Blocat]            BIT             CONSTRAINT [DF_AmixAmortizare_Blocat] DEFAULT ((0)) NOT NULL,
    [IDBK]              INT             NULL,
    CONSTRAINT [PK_AmixAmortizare] PRIMARY KEY CLUSTERED ([IDMijlocFix] ASC, [Luna] ASC, [An] ASC),
    CONSTRAINT [FK_AmixAmortizare_AmixRegistru] FOREIGN KEY ([IDMijlocFix]) REFERENCES [dbo].[AmixRegistru] ([IDMijlocFix])
);

